Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	314
Missing cells	483
Missing cells (%)	10.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	39.2 KiB
Average record size in memory	128.0 B

Variable types

Numeric	13
Categorical	1
DateTime	1

Warnings

`YEAR` is highly correlated with `formatted_date`	High correlation
`PM_RETIRO` is highly correlated with `PM_CIUDADLINEAL` and 1 other fields	High correlation
`PM_CIUDADLINEAL` is highly correlated with `PM_RETIRO` and 1 other fields	High correlation
`PM_CENTRO` is highly correlated with `PM_RETIRO` and 1 other fields	High correlation
`DEW_POINT` is highly correlated with `TEMPERATURE`	High correlation
`PREASSURE` is highly correlated with `TEMPERATURE`	High correlation
`TEMPERATURE` is highly correlated with `DEW_POINT` and 1 other fields	High correlation
`formatted_date` is highly correlated with `YEAR`	High correlation
`PM_RETIRO` has 158 (50.3%) missing values	Missing
`PM_VALLECAS` has 165 (52.5%) missing values	Missing
`PM_CIUDADLINEAL` has 158 (50.3%) missing values	Missing
`TEMPERATURE` has unique values	Unique
`WIND_SPEED` has unique values	Unique
`formatted_date` has unique values	Unique
`COMMULATIVE_PRECIPITATION` has 130 (41.4%) zeros	Zeros

Reproduction

Analysis started	2021-05-04 16:39:45.532116
Analysis finished	2021-05-04 16:42:47.818598
Duration	3 minutes and 2.29 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

YEAR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2012.5
Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	2010
5-th percentile	2010
Q1	2011
median	2012.5
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.716765664
Coefficient of variation (CV)	0.0008530512616
Kurtosis	-1.276741608
Mean	2012.5
Median Absolute Deviation (MAD)	1.5
Skewness	0
Sum	631925
Variance	2.947284345
Monotocity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2015	53	16.9%
2010	53	16.9%
2014	52	16.6%
2013	52	16.6%
2012	52	16.6%
2011	52	16.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010	53	16.9%
2011	52	16.6%
2012	52	16.6%
2013	52	16.6%
2014	52	16.6%

Value	Count	Frequency (%)
2015	53	16.9%
2014	52	16.6%
2013	52	16.6%
2012	52	16.6%
2011	52	16.6%

Week
Real number (ℝ_≥0)

Distinct	53
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26.66878981
Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	14
median	27
Q3	40
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	15.13238219
Coefficient of variation (CV)	0.5674191556
Kurtosis	-1.19964865
Mean	26.66878981
Median Absolute Deviation (MAD)	13
Skewness	0.0008578062142
Sum	8374
Variance	228.9889909
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	6	1.9%
26	6	1.9%
24	6	1.9%
23	6	1.9%
22	6	1.9%
21	6	1.9%
20	6	1.9%
19	6	1.9%
18	6	1.9%
17	6	1.9%
Other values (43)	254	80.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	1.9%
2	6	1.9%
3	6	1.9%
4	6	1.9%
5	6	1.9%

Value	Count	Frequency (%)
53	2	0.6%
52	6	1.9%
51	6	1.9%
50	6	1.9%
49	6	1.9%

SEASON
Categorical

Distinct	4
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	4.9 KiB

1	84
2	79
3	78
4	73

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	314
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

Most occurring characters

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	314	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	314	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	314	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	84	26.8%
2	79	25.2%
3	78	24.8%
4	73	23.2%

PM_RETIRO
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	156
Distinct (%)	100.0%
Missing	158
Missing (%)	50.3%
Infinite	0
Infinite (%)	0.0%

Mean	89.50134276
Minimum	18.66071429
Maximum	266.6325301
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	18.66071429
5-th percentile	35.69544861
Q1	60.41791239
median	80.12340648
Q3	106.8875578
95-th percentile	168.1834023
Maximum	266.6325301
Range	247.9718158
Interquartile range (IQR)	46.46964539

Descriptive statistics

Standard deviation	42.12679801
Coefficient of variation (CV)	0.4706834189
Kurtosis	1.451146598
Mean	89.50134276
Median Absolute Deviation (MAD)	23.35138157
Skewness	1.057313675
Sum	13962.20947
Variance	1774.66711
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68.32335329	1	0.3%
38.74404762	1	0.3%
48.18787879	1	0.3%
101.5301205	1	0.3%
91.62424242	1	0.3%
139.9052632	1	0.3%
99.16071429	1	0.3%
99.21212121	1	0.3%
24.18787879	1	0.3%
140.5644172	1	0.3%
Other values (146)	146	46.5%
(Missing)	158	50.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18.66071429	1	0.3%
22.95238095	1	0.3%
24.18787879	1	0.3%
26.04819277	1	0.3%
29.6375	1	0.3%

Value	Count	Frequency (%)
266.6325301	1	0.3%
214.4390244	1	0.3%
194.4099379	1	0.3%
176.2160494	1	0.3%
175.6845238	1	0.3%

PM_VALLECAS
Real number (ℝ_≥0)

MISSING

Distinct	149
Distinct (%)	100.0%
Missing	165
Missing (%)	52.5%
Infinite	0
Infinite (%)	0.0%

Mean	91.08402763
Minimum	6
Maximum	248.3115942
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	6
5-th percentile	32.46860894
Q1	61.50595238
median	82.14102564
Q3	107.9814815
95-th percentile	181.0188406
Maximum	248.3115942
Range	242.3115942
Interquartile range (IQR)	46.4755291

Descriptive statistics

Standard deviation	45.79859942
Coefficient of variation (CV)	0.5028170208
Kurtosis	0.6674908442
Mean	91.08402763
Median Absolute Deviation (MAD)	21.56966618
Skewness	0.9266844979
Sum	13571.52012
Variance	2097.511709
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
194.4011976	1	0.3%
53.3902439	1	0.3%
130.3669065	1	0.3%
10.45454545	1	0.3%
248.3115942	1	0.3%
75.2	1	0.3%
106.8	1	0.3%
46.81927711	1	0.3%
108.4578313	1	0.3%
107.9814815	1	0.3%
Other values (139)	139	44.3%
(Missing)	165	52.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	0.3%
9.333333333	1	0.3%
10.45454545	1	0.3%
13.02	1	0.3%
19.14035088	1	0.3%

Value	Count	Frequency (%)
248.3115942	1	0.3%
208	1	0.3%
197.6506024	1	0.3%
196.595092	1	0.3%
195.0472973	1	0.3%

PM_CIUDADLINEAL
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	156
Distinct (%)	100.0%
Missing	158
Missing (%)	50.3%
Infinite	0
Infinite (%)	0.0%

Mean	89.10691932
Minimum	13.7797619
Maximum	249.6319018
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	13.7797619
5-th percentile	34.19441587
Q1	59.19995301
median	77.20045181
Q3	108.1034979
95-th percentile	168.0887157
Maximum	249.6319018
Range	235.8521399
Interquartile range (IQR)	48.90354491

Descriptive statistics

Standard deviation	43.45077231
Coefficient of variation (CV)	0.4876251209
Kurtosis	0.6841967409
Mean	89.10691932
Median Absolute Deviation (MAD)	22.34314661
Skewness	0.9854582157
Sum	13900.67941
Variance	1887.969614
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82.76470588	1	0.3%
78.25149701	1	0.3%
45.54268293	1	0.3%
73.54216867	1	0.3%
55.77710843	1	0.3%
159.3915663	1	0.3%
174.8073394	1	0.3%
104.6607143	1	0.3%
90.23780488	1	0.3%
79.72	1	0.3%
Other values (146)	146	46.5%
(Missing)	158	50.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13.7797619	1	0.3%
17.72289157	1	0.3%
23.20714286	1	0.3%
28.54658385	1	0.3%
30.23493976	1	0.3%

Value	Count	Frequency (%)
249.6319018	1	0.3%
208.1515152	1	0.3%
194.1677019	1	0.3%
186.8773006	1	0.3%
183.2108434	1	0.3%

PM_CENTRO
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	311
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	96.21641491
Minimum	17.73214286
Maximum	271.8433735
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	17.73214286
5-th percentile	36.55089286
Q1	66.08725163
median	86.35825119
Q3	118.6997166
95-th percentile	182.0143933
Maximum	271.8433735
Range	254.1112306
Interquartile range (IQR)	52.61246501

Descriptive statistics

Standard deviation	45.41258061
Coefficient of variation (CV)	0.4719837115
Kurtosis	1.644776369
Mean	96.21641491
Median Absolute Deviation (MAD)	25.02874242
Skewness	1.154750541
Sum	30211.95428
Variance	2062.302478
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98.45833333	2	0.6%
83.25595238	2	0.6%
70.83333333	2	0.6%
115.9027778	1	0.3%
105.8614458	1	0.3%
126.005988	1	0.3%
80.01796407	1	0.3%
61.81481481	1	0.3%
70.26946108	1	0.3%
68.20833333	1	0.3%
Other values (301)	301	95.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
17.73214286	1	0.3%
21.51190476	1	0.3%
23.91666667	1	0.3%
25.78289474	1	0.3%
29.18562874	1	0.3%

Value	Count	Frequency (%)
271.8433735	1	0.3%
266	1	0.3%
254.4047619	1	0.3%
242.9345238	1	0.3%
234.327381	1	0.3%

DEW_POINT
Real number (ℝ)

HIGH CORRELATION

Distinct	311
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.029029838
Minimum	-21.68229167
Maximum	23.61904762
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	-21.68229167
5-th percentile	-18.67529762
Q1	-10.11309524
median	2.74702381
Q3	14.74553571
95-th percentile	21.37113095
Maximum	23.61904762
Range	45.30133929
Interquartile range (IQR)	24.85863095

Descriptive statistics

Standard deviation	13.383303
Coefficient of variation (CV)	6.595912364
Kurtosis	-1.344081318
Mean	2.029029838
Median Absolute Deviation (MAD)	12.31845238
Skewness	-0.04594958744
Sum	637.1153693
Variance	179.1127991
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-18.08333333	2	0.6%
-1.375	2	0.6%
17.4702381	2	0.6%
-1.982142857	1	0.3%
7.303571429	1	0.3%
-19.54166667	1	0.3%
-6.523809524	1	0.3%
-19.45833333	1	0.3%
-9.202380952	1	0.3%
19.94642857	1	0.3%
Other values (301)	301	95.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-21.68229167	1	0.3%
-21.18452381	1	0.3%
-20.89880952	1	0.3%
-20.82142857	1	0.3%
-20.16071429	1	0.3%

Value	Count	Frequency (%)
23.61904762	1	0.3%
23.47619048	1	0.3%
23.375	1	0.3%
23.24404762	1	0.3%
23.13095238	1	0.3%

HUMIDITY
Real number (ℝ_≥0)

Distinct	310
Distinct (%)	99.0%
Missing	1
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	54.72794453
Minimum	18.3452381
Maximum	97.22916667
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	18.3452381
5-th percentile	29.53690476
Q1	42.49404762
median	55.4047619
Q3	65.9047619
95-th percentile	79.2047619
Maximum	97.22916667
Range	78.88392857
Interquartile range (IQR)	23.41071429

Descriptive statistics

Standard deviation	15.6393306
Coefficient of variation (CV)	0.2857649914
Kurtosis	-0.7701986643
Mean	54.72794453
Median Absolute Deviation (MAD)	12.00595238
Skewness	-0.07419284519
Sum	17129.84664
Variance	244.5886615
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55.4047619	2	0.6%
50.98809524	2	0.6%
65.88690476	2	0.6%
68.16071429	1	0.3%
30.765625	1	0.3%
77.26785714	1	0.3%
33.61309524	1	0.3%
64.51785714	1	0.3%
85.51190476	1	0.3%
69.69642857	1	0.3%
Other values (300)	300	95.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18.3452381	1	0.3%
21.44047619	1	0.3%
21.50595238	1	0.3%
22.00595238	1	0.3%
24.13095238	1	0.3%

Value	Count	Frequency (%)
97.22916667	1	0.3%
85.51190476	1	0.3%
84.88095238	1	0.3%
83.43452381	1	0.3%
82.79761905	1	0.3%

PREASSURE
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	305
Distinct (%)	97.4%
Missing	1
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	1016.527149
Minimum	997.2678571
Maximum	1036.470238
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	997.2678571
5-th percentile	1002.133333
Q1	1008.095238
median	1016.994048
Q3	1023.982143
95-th percentile	1030.82619
Maximum	1036.470238
Range	39.20238095
Interquartile range (IQR)	15.88690476

Descriptive statistics

Standard deviation	9.321727306
Coefficient of variation (CV)	0.009170170532
Kurtosis	-1.137794415
Mean	1016.527149
Median Absolute Deviation (MAD)	7.916666667
Skewness	-0.02445234755
Sum	318172.9976
Variance	86.89459996
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000.964286	2	0.6%
1023.982143	2	0.6%
1018.458333	2	0.6%
1022.559524	2	0.6%
1029.625	2	0.6%
1004.875	2	0.6%
1018.75	2	0.6%
1011.857143	2	0.6%
1002.202381	1	0.3%
1003.797619	1	0.3%
Other values (295)	295	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
997.2678571	1	0.3%
1000.416667	1	0.3%
1000.547619	1	0.3%
1000.684524	1	0.3%
1000.869048	1	0.3%

Value	Count	Frequency (%)
1036.470238	1	0.3%
1034.047619	1	0.3%
1033.635417	1	0.3%
1033.354167	1	0.3%
1032.946429	1	0.3%

TEMPERATURE
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.84754088
Minimum	-1.862217018
Maximum	31.47111632
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	-1.862217018
5-th percentile	3.592414374
Q1	8.428815379
median	19.38095238
Q3	26.88729508
95-th percentile	30.03449454
Maximum	31.47111632
Range	33.33333333
Interquartile range (IQR)	18.4584797

Descriptive statistics

Standard deviation	9.282351052
Coefficient of variation (CV)	0.5200913177
Kurtosis	-1.389319215
Mean	17.84754088
Median Absolute Deviation (MAD)	8.62363388
Skewness	-0.20254832
Sum	5604.127835
Variance	86.16204105
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.70725995	1	0.3%
6.393052303	1	0.3%
27.6459797	1	0.3%
24.5185402	1	0.3%
26.71409055	1	0.3%
5.065964091	1	0.3%
8.617876659	1	0.3%
7.485948478	1	0.3%
29.10967994	1	0.3%
24.33313817	1	0.3%
Other values (304)	304	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.862217018	1	0.3%
0.1576893052	1	0.3%
1.204234973	1	0.3%
1.995446266	1	0.3%
2.323965652	1	0.3%

Value	Count	Frequency (%)
31.47111632	1	0.3%
31.11494926	1	0.3%
30.95882123	1	0.3%
30.93442623	1	0.3%
30.83380779	1	0.3%

WIND_SPEED
Real number (ℝ_≥0)

UNIQUE

Distinct	314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.34791701
Minimum	3.302202381
Maximum	177.1026667
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	3.302202381
5-th percentile	5.621282738
Q1	9.954895833
median	15.47050595
Q3	27.25004464
95-th percentile	65.0183404
Maximum	177.1026667
Range	173.8004643
Interquartile range (IQR)	17.29514881

Descriptive statistics

Standard deviation	23.12628606
Coefficient of variation (CV)	0.9905074637
Kurtosis	11.44095404
Mean	23.34791701
Median Absolute Deviation (MAD)	6.978541667
Skewness	2.936798241
Sum	7331.24594
Variance	534.8251067
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.26041667	1	0.3%
12.31196429	1	0.3%
22.3825	1	0.3%
20.62815476	1	0.3%
12.24190476	1	0.3%
10.73619048	1	0.3%
66.62660714	1	0.3%
10.46202381	1	0.3%
4.999940476	1	0.3%
9.917559524	1	0.3%
Other values (304)	304	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.302202381	1	0.3%
3.706826347	1	0.3%
4.200238095	1	0.3%
4.219583333	1	0.3%
4.265119048	1	0.3%

Value	Count	Frequency (%)
177.1026667	1	0.3%
140.5269048	1	0.3%
138.5585714	1	0.3%
115.4180357	1	0.3%
110.7311905	1	0.3%

COMMULATIVE_PRECIPITATION
Real number (ℝ_≥0)

ZEROS

Distinct	127
Distinct (%)	40.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3192.679299
Minimum	0
Maximum	999990
Zeros	130
Zeros (%)	41.4%
Memory size	4.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.8
Q3	10.05
95-th percentile	39.05
Maximum	999990
Range	999990
Interquartile range (IQR)	10.05

Descriptive statistics

Standard deviation	56432.25065
Coefficient of variation (CV)	17.67551494
Kurtosis	313.9999333
Mean	3192.679299
Median Absolute Deviation (MAD)	0.8
Skewness	17.72004233
Sum	1002501.3
Variance	3184598913
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	130	41.4%
0.1	10	3.2%
0.7	5	1.6%
0.2	5	1.6%
4.9	4	1.3%
3.1	4	1.3%
0.8	4	1.3%
3.4	4	1.3%
10.1	3	1.0%
1.1	3	1.0%
Other values (117)	142	45.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	130	41.4%
0.1	10	3.2%
0.2	5	1.6%
0.3	1	0.3%
0.4	2	0.6%

Value	Count	Frequency (%)
999990	1	0.3%
223	1	0.3%
102.3	1	0.3%
75.8	1	0.3%
74.1	1	0.3%

formatted_date
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2012766.688
Minimum	2010010
Maximum	2015530
Zeros	0
Zeros (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	2010010
5-th percentile	2010166.5
Q1	2011262.5
median	2012765
Q3	2014267.5
95-th percentile	2015373.5
Maximum	2015530
Range	5520
Interquartile range (IQR)	3005

Descriptive statistics

Standard deviation	1723.421958
Coefficient of variation (CV)	0.0008562452708
Kurtosis	-1.256219614
Mean	2012766.688
Median Absolute Deviation (MAD)	1505
Skewness	0.003308513388
Sum	632008740
Variance	2970183.244
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2010110	1	0.3%
2015250	1	0.3%
2011290	1	0.3%
2013340	1	0.3%
2010270	1	0.3%
2015060	1	0.3%
2012320	1	0.3%
2014370	1	0.3%
2011300	1	0.3%
2013350	1	0.3%
Other values (304)	304	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010010	1	0.3%
2010020	1	0.3%
2010030	1	0.3%
2010040	1	0.3%
2010050	1	0.3%

Value	Count	Frequency (%)
2015530	1	0.3%
2015520	1	0.3%
2015510	1	0.3%
2015500	1	0.3%
2015490	1	0.3%

YearWeek
Date

Distinct	313
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Memory size	4.9 KiB

Minimum	2010-01-10 00:00:00
Maximum	2016-01-10 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	YEAR	Week	SEASON	PM_RETIRO	PM_VALLECAS	PM_CIUDADLINEAL	PM_CENTRO	DEW_POINT	HUMIDITY	PREASSURE	TEMPERATURE	WIND_SPEED	COMMULATIVE_PRECIPITATION	formatted_date	YearWeek
0	2010	1	4	NaN	NaN	NaN	74.119048	-19.976190	50.678571	1031.470238	-1.862217	32.778571	0.0	2010010	2010-01-10
1	2010	2	4	NaN	NaN	NaN	88.250000	-18.083333	49.750000	1031.345238	0.157689	43.464464	0.0	2010020	2010-01-17
2	2010	3	4	NaN	NaN	NaN	131.897059	-14.202381	46.404762	1028.255952	5.017174	38.843810	0.0	2010030	2010-01-24
3	2010	4	4	NaN	NaN	NaN	63.413534	-17.744048	29.684524	1023.738095	7.002927	51.740417	0.0	2010040	2010-01-31
4	2010	5	4	NaN	NaN	NaN	76.416667	-14.017857	52.934524	1027.625000	3.836456	10.406071	0.0	2010050	2010-02-07
5	2010	6	4	NaN	NaN	NaN	80.017964	-16.982143	38.130952	1029.416667	5.144028	14.127321	0.0	2010060	2010-02-14
6	2010	7	4	NaN	NaN	NaN	98.898810	-16.130952	36.339286	1022.559524	6.393052	11.960714	0.0	2010070	2010-02-21
7	2010	8	4	NaN	NaN	NaN	133.523810	-5.494048	63.172619	1015.505952	8.617877	17.373036	4.7	2010080	2010-02-28
8	2010	9	1	NaN	NaN	NaN	94.410714	-10.154762	52.607143	1025.464286	7.485948	24.873631	5.1	2010090	2010-03-07
9	2010	10	1	NaN	NaN	NaN	70.553571	-10.559524	49.101190	1024.339286	8.149493	26.571786	10.1	2010100	2010-03-14

Last rows

	YEAR	Week	SEASON	PM_RETIRO	PM_VALLECAS	PM_CIUDADLINEAL	PM_CENTRO	DEW_POINT	HUMIDITY	PREASSURE	TEMPERATURE	WIND_SPEED	COMMULATIVE_PRECIPITATION	formatted_date	YearWeek
304	2015	44	3	29.637500	74.500000	28.546584	29.839286	-3.041667	50.154762	1024.220238	14.609290	29.899583	4.3	2015440	2015-11-08
305	2015	45	3	94.523810	52.193548	96.255952	93.351190	1.904762	75.504132	1025.198347	12.833333	17.471548	999990.0	2015450	2015-11-15
306	2015	46	3	175.684524	208.000000	183.210843	175.952381	4.898204	NaN	NaN	13.070973	3.706826	0.0	2015460	2015-11-22
307	2015	47	3	57.363636	70.647059	59.298137	60.482143	0.571429	97.229167	1033.354167	9.862022	16.389226	7.1	2015470	2015-11-29
308	2015	48	3	140.564417	6.000000	148.794521	135.416667	-9.202381	70.250000	1031.916667	3.987705	20.563631	0.0	2015480	2015-12-06
309	2015	49	3	176.216049	174.142857	168.098765	160.455090	-7.706587	59.700599	1024.952096	7.981152	57.305150	0.0	2015490	2015-12-13
310	2015	50	4	170.718563	193.800000	179.491018	169.714286	-3.577381	74.410714	1027.988095	8.403201	5.003631	0.0	2015500	2015-12-20
311	2015	51	4	90.795181	13.020000	97.029940	97.454545	-9.684524	55.404762	1029.779762	7.080991	77.864940	0.7	2015510	2015-12-27
312	2015	52	4	266.632530	248.311594	249.631902	254.404762	-6.523810	76.750000	1027.345238	5.539227	4.200238	0.0	2015520	2016-01-03
313	2015	53	4	139.905263	181.055556	150.473684	154.229167	-9.229167	63.687500	1031.687500	5.473361	12.619271	0.0	2015530	2016-01-10

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows